DatabaseTypeNameToJDBC.java

/*
 * Copyright 2013 Matt Sicker and Contributors
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package atg.tools.dynunit.adapter.gsa;

import atg.adapter.gsa.DatabaseTableInfo;
import org.jetbrains.annotations.Nullable;

/**
 * The purpose of this class is to map from a the database specific type name
 * for a column to the <code>java.sql.Types</code> for that column. Given a
 * DatabaseTableInfo for a given database it will return the jdbc type for the
 * supported GSA types.
 *
 * @author adamb
 * @version $Id: //test/UnitTests/base/main/src/Java/atg/adapter/gsa/DatabaseTypeNameToJDBC.java#2
 *          $
 * @see java.sql.Types
 */
public class DatabaseTypeNameToJDBC {

    @Nullable
    private DatabaseTableInfo mTableInfo = null;

    private static final int UNKNOWN = -9999;

    // -------------------------------

    /**
     * Creates a new instance of this class initialized with the given
     * DatabaseTableInfo object.
     *
     * @param pTableInfo
     */
    public DatabaseTypeNameToJDBC(DatabaseTableInfo pTableInfo) {
        mTableInfo = pTableInfo;
    }

    // -------------------------------

    /**
     * Given a database specific type name, returns the matching
     * <code>java.sql.Types</code> constant. If there is no suitable match this
     * method returns the constant <code>UNKNOWN</code>.
     *
     * @param pTypeName
     *
     * @return
     */
    public int databaseTypeNametoJDBCType(String pTypeName) {
        // Walk the DatabaseTableInfo and do a comparison.
        if ( mTableInfo.mVarcharType.equals(pTypeName) ) {
            return java.sql.Types.VARCHAR;
        } else if ( mTableInfo.mIntType.equals(pTypeName) ) {
            // Fix for MS SQLServer
            if ( "NUMERIC".equals(pTypeName) ) {
                return java.sql.Types.NUMERIC;
            } else {
                return java.sql.Types.INTEGER;
            }
        } else if ( mTableInfo.mBinaryType.equals(pTypeName) ) {
            return java.sql.Types.BLOB;
        } else if ( mTableInfo.mLongVarcharType.equals(pTypeName) ) {
            return java.sql.Types.LONGVARCHAR;
        } else if ( mTableInfo.mTimestampType.equals(pTypeName) ) {
            return java.sql.Types.TIMESTAMP;
        } else if ( mTableInfo.mCharType.equals(pTypeName) ) {
            return java.sql.Types.CHAR;
        } else if ( mTableInfo.mDateType.equals(pTypeName) ) {
            return java.sql.Types.DATE;
        } else if ( mTableInfo.mDecimalType.equals(pTypeName) ) {
            return java.sql.Types.DECIMAL;
        } else {
            return UNKNOWN;
        }
    }
}